SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.[DnnProduct_CDS_BillingConfigUpdate]
	@ID int,
	@Name nvarchar(256),
	@Description nvarchar(1024),
	@MonthlyMinimum decimal(18,2),
	@UnitBasedPricing bit,
	@TransactionFees nvarchar(max),
	@IncludedStorage bit,
	@StorageIncrement decimal(18,2),
	@StorageFee decimal(18,2),
	@BWSurcharge decimal(18,2),
	@BWBaseSize decimal(18,2),
	@BWAvgIncrement decimal(18,2)
AS
BEGIN
	UPDATE [DnnProduct_CDS_BillingConfig]
	SET [Name] = @Name,
	  [Description] = @Description,
      [MonthlyMinimum] = @MonthlyMinimum,
      [UnitBasedPricing] = @UnitBasedPricing,
      [TransactionFees] = @TransactionFees,
      [IncludedStorage] = @IncludedStorage,
      [StorageIncrement] = @StorageIncrement,
      [StorageFee] = @StorageFee,
      [BWSurcharge] = @BWSurcharge,
      [BWBaseSize] = @BWBaseSize,
      [BWAvgIncrement] = @BWAvgIncrement
	WHERE [ID] = @ID
END
GO
